SetConditionalFormatting(CellRange[],Boolean,IConditionalFormattingRule[]) Method

In This Topic

Sets conditional formatting for a specified ranges of cells on the sheet based on specified rules.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetConditionalFormatting( _
   ByVal cellRanges() As CellRange, _
   ByVal isCombinable As Boolean, _
   ByVal ParamArray rules() As IConditionalFormattingRule _
)

'Usage
 
Dim instance As SheetView
Dim cellRanges() As CellRange
Dim isCombinable As Boolean
Dim rules() As IConditionalFormattingRule
 
instance.SetConditionalFormatting(cellRanges, isCombinable, rules)

public void SetConditionalFormatting( 
   CellRange[] cellRanges,
   bool isCombinable,
   params IConditionalFormattingRule[] rules
)

Parameters

cellRanges: Cell ranges
isCombinable: Indicates that rule(s) can be merged into existing conditional formatting if they affect the same cell range(s).
rules: Rules to apply for the specified range of cells

Reference

SheetView Class
SheetView Members
Overload List